﻿


-- =============================================
-- 
-- 
-- 2012-07-30  修改待付合计金额
-- 2013-12-13 修改，值班补助改为临时补助
-- =============================================
CREATE PROCEDURE [dbo].[proc_Wage_Update_DF]
	(
		@Id int,
		--@FAllowance decimal(18,2),	
		@LsBonus decimal(18,2),	
		@ZBwance  decimal(18,2),
		@ce decimal(18,2)
		
	)
AS
	Update a Set
		
 
--DFHeJi  =		round(DFHeJi-ZBwance+ @ZBwance,0) ,
--YFHeJi  =		a.HeJiWage+round(DFHeJi-ZBwance+ @ZBwance,0)  ,
--ZBwance   =		@ZBwance  ,
DFHeJi  =		DFHeJi-ZBwance-LsBonus+ @ZBwance+@LsBonus ,
YFHeJi  =		a.HeJiWage+DFHeJi-ZBwance-LsBonus+ @ZBwance+@LsBonus  ,
ZBwance   =		@ZBwance  ,
LsBonus=@LsBonus,
	
	HRFlagDate=GetDate()
	
	FROM Employee_Wage AS a
	Where Id=@Id
	RETURN






